﻿CREATE TABLE [dbo].[BatchResubmissionMessage]
(
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[MessageBatchID] [uniqueidentifier] NOT NULL,
	[MessageID] [uniqueidentifier] NOT NULL,
	[CreatedOn] [datetime] NOT NULL,
	[Status] NVARCHAR(25) NOT NULL,
	[ErrorMessage]  VARCHAR (MAX)    NULL,
	[ProcessingServer] NVARCHAR(50) NULL,
	[ProcessingID] UNIQUEIDENTIFIER NULL,
	[LastModified] DATETIME NOT NULL DEFAULT GETDATE(), 
    CONSTRAINT [PK_BatchResubmissionMessage] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
);
